package com.qcu.mapper;

import com.qcu.entity.ExaminationInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;

/**
* @author MyComputer
* @description 针对表【examination_info】的数据库操作Mapper
* @createDate 2025-04-10 10:23:40
* @Entity com.qcu.entity.ExaminationInfo
*/
public interface ExaminationInfoMapper extends BaseMapper<ExaminationInfo> {

    @Select("select distinct u.username username , u.email email , o.name name , e.content info , e.create_at time from examination_info e \n" +
            "\tleft join order_info o on e.id = o.inhabitant_id\n" +
            "\tleft join user u on u.id = o.user_id\n" +
            "where e.id = #{inhabitantId}")
    HashMap<String, String> sendResultToUser(String inhabitantId);
}




